﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using GreenyMeter.DOM.DataBaseAcces;

namespace GreenyMeter.DOM.Objets
{
    public class Ingredients
    {

          #region Atributes


        private int _ingredientId;
        public int IngredientId
        {
            get { return _ingredientId; }
            set { _ingredientId = value; }
        }

        private int _ingredientTypeId;
        public int IngredientTypeId
        {
            get { return _ingredientTypeId; }
            set { _ingredientTypeId = value; }
        }

        private int _foodTypeId;
        public int FoodTypeId
        {
            get { return _foodTypeId; }
            set { _foodTypeId = value; }
        }

        private string _foodName;
        public string FoodName
        {
            get { return _foodName; }
            set { _foodName = value; }
        }

        private string _description;
        public string Description
        {
            get { return _description; }
            set { _description = value; }
        }

        private string _foodImgUrl;
        public string FoodImgUrl
        {
            get { return _foodImgUrl; }
            set { _foodImgUrl = value; }
        }



       


        #endregion

        public static DataTable getAllFoodTypes()
        {

            SqlDataAcces sqlQuery = new SqlDataAcces();
            List<SqlDaAccesParameters> param = new List<SqlDaAccesParameters>();
            return sqlQuery.GetDataTable("usp_GetAllFoodTypes", param);
        }
        public static DataTable getAllFoodCategories()
        {

            SqlDataAcces sqlQuery = new SqlDataAcces();
            List<SqlDaAccesParameters> param = new List<SqlDaAccesParameters>();
            return sqlQuery.GetDataTable("usp_GetAllFoodCategories", param);
        }

       
    }
}